/*
 *  $Id: VirtuosoSPARQLExample9.java,v 1.1 2008/06/18 08:21:12 source Exp $
 *
 *  This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
 *  project.
 *
 *  Copyright (C) 1998-2008 OpenLink Software
 *
 *  This project is free software; you can redistribute it and/or modify it
 *  under the terms of the GNU General Public License as published by the
 *  Free Software Foundation; only version 2 of the License, dated June 1991.
 *
 *  This program is distributed in the hope that it will be useful, but
 *  WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 *  General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License along
 *  with this program; if not, write to the Free Software Foundation, Inc.,
 *  51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
 *
 */

//package virtuoso.jena.driver;
package com.gun3y.samples;

import java.util.Iterator;

import virtuoso.jena.driver.VirtGraph;
import virtuoso.jena.driver.VirtuosoQueryExecution;
import virtuoso.jena.driver.VirtuosoQueryExecutionFactory;
import virtuoso.jena.driver.VirtuosoUpdateFactory;
import virtuoso.jena.driver.VirtuosoUpdateRequest;

import com.hp.hpl.jena.graph.Graph;
import com.hp.hpl.jena.graph.Node;
import com.hp.hpl.jena.graph.Triple;
import com.hp.hpl.jena.query.Query;
import com.hp.hpl.jena.query.QueryFactory;
import com.hp.hpl.jena.query.QuerySolution;
import com.hp.hpl.jena.query.ResultSet;
import com.hp.hpl.jena.rdf.model.Model;
import com.hp.hpl.jena.rdf.model.RDFNode;

public class VirtuosoSPARQLExample9 {

    /**
     * Executes a SPARQL query against a virtuoso url and prints results.
     */
    public static void main(String[] args) {

	/* STEP 1 */
	VirtGraph set = new VirtGraph("jdbc:virtuoso://localhost:1111", "dba", "dba");

	/* STEP 2 */
	String str = "CLEAR GRAPH <http://test1>";
	VirtuosoUpdateRequest vur = VirtuosoUpdateFactory.create(str, set);
	vur.exec();

	str = "INSERT INTO GRAPH <http://test1> { <http://aa> <http://bb> 'cc' . <http://aa1> <http://bb> 123. }";
	vur = VirtuosoUpdateFactory.create(str, set);
	vur.exec();

	/* Select all data in virtuoso */
	Query sparql = QueryFactory.create("SELECT * FROM <http://test1> WHERE { ?s ?p ?o }");
	VirtuosoQueryExecution vqe = VirtuosoQueryExecutionFactory.create(sparql, set);
	ResultSet results = vqe.execSelect();
	System.out.println("\nSELECT results:");
	while (results.hasNext()) {
	    QuerySolution rs = results.nextSolution();
	    RDFNode s = rs.get("s");
	    RDFNode p = rs.get("p");
	    RDFNode o = rs.get("o");
	    System.out.println(" { " + s + " " + p + " " + o + " . }");
	}

	sparql = QueryFactory.create("DESCRIBE <http://aa> FROM <http://test1>");
	vqe = VirtuosoQueryExecutionFactory.create(sparql, set);

	Model model = vqe.execDescribe();
	Graph g = model.getGraph();
	System.out.println("\nDESCRIBE results:");
	for (Iterator<Triple> i = g.find(Node.ANY, Node.ANY, Node.ANY); i.hasNext();) {
	    Triple t = (Triple) i.next();
	    System.out.println(" { " + t.getSubject() + " " + t.getPredicate() + " " + t.getObject() + " . }");
	}

	sparql = QueryFactory.create("CONSTRUCT { ?x <http://test> ?y } FROM <http://test1> WHERE { ?x <http://bb> ?y }");
	vqe = VirtuosoQueryExecutionFactory.create(sparql, set);

	model = vqe.execConstruct();
	g = model.getGraph();
	System.out.println("\nCONSTRUCT results:");
	for (Iterator<Triple> i = g.find(Node.ANY, Node.ANY, Node.ANY); i.hasNext();) {
	    Triple t = (Triple) i.next();
	    System.out.println(" { " + t.getSubject() + " " + t.getPredicate() + " " + t.getObject() + " . }");
	}

	sparql = QueryFactory.create("ASK FROM <http://test1> WHERE { <http://aa> <http://bb> ?y }");
	vqe = VirtuosoQueryExecutionFactory.create(sparql, set);

	boolean res = vqe.execAsk();
	System.out.println("\nASK results: " + res);

    }
}
